Printing a Sales Rep Margin Report

Once you have entered all of the required information needed to generate a Sales Rep Margin Report, command options will appear allowing you to print or choose from a set of other print options.

Printing a Sales Rep Margin Report

If you entered Y (Y=yes) in the Broker field, the report will display totals by customer for each broker. If you enter N (N=no), the system will generate a report that does not include any information about brokers.

If you answer Y (Y=yes) to Broker, an additional option to include NULL brokers will appear. If you answer yes to Null Broker, all non-broker sales by the customer class will be grouped together under “NULL BROKER”. The report will then list the remaining sales by broker. If you answer N (N=no) to “Null Broker” the report will only include broker sales and not the remaining non-broker sales. 

Note: Subtotals are listed for each sales rep. If the Broker field is set to N (N=no) above the line and below the line sales, by class, will appear. If Broker field is set to Y (Y=yes), customer (or customers with items detail) will subtotal by class.

An uncosted above the line“Above the line” refers to a customer class assigned to the customer used to segregate customers that are part of a company’s regular business. Above the line customers are generally profitable and represent sales at the normal markup. and below the line"Below the line” is a customer class assigned to the customer used to segregate customers that are not part of normal business. This customer class is also referred to as low margin customers or those sold at a less than normal markup. summary page for each sales rep will also be included as part of the report.

Separate summary pages will be generated by sales rep for both above and below the line classes.  

A grand total section/page listing the grand total above the line and the grand total below the line will also be generated.  

The report may be printed in three versions:

• Summary – Generates a report which displays sales rep and customer totals.
• Detail with Customer Totals – Generates a report which displays customers and item detail by sales rep.
• Detail with no Customer Total – Generates a report which displays item gross margin by sales rep.

The following information will print on the report based on above and below the line customer classes:

• Customer – Customers within each particular customer class (i.e. above the line/below the line) are listed within this column, followed by the sales rep's name
• Amount Invoiced (Product) – The dollar amount invoiced for the product
• Amount Invoiced (Other) – The dollar amount invoiced for non-product items, such as price exceptions set for customers (price allocations, cost buckets, cost adjustments, cost allocations, etc.)
• Amount Invoiced (Total) – The total dollar amount invoiced; Product (the amount of product invoiced) plus Other (non-product items invoiced)
• Actual Cost (If report was run using actual cost) – The total cost attributed to the item when Cost of Goods Sold was run.
• Standard Cost (If report was run using standard cost) – The standard cost of the product, in dollars
• Pounds – The item amount, in pounds

• Gross Profit – The total dollar amount of profit based on the gross profit calculation method set in Ledger Options
• Gross Margin – The gross profit expressed as a percentage of the total amount invoiced based on the gross margin calculation method set in Ledger Options
• Grand Total – The grand total for each of the columns (headers) listed on the report.

Note: Each customer and sales rep will have subtotals correlating with each of the report columns (headers) previously listed (see above). If Broker field is set to Y (Yes) the report will also display subtotals for each of the report columns (headers) by broker.

Uncosted Items Page

Items that have been invoiced but have not yet been costed are itemized at the end of the report in a separate uncosted item report for customers above and below the line.

• SP – The sales rep
• Broker –The broker ID, if you have selected Y in the Broker field
• Customer – The customer code and name of the customer
• Item – The item group and item name
• Order – The sales order number
• Invoice – The invoice number if the order is invoiced
• Quantity – The quantity of the item shipped to the customer
• IN UN – The invoicing unit of measure
• Selling Price – The total per unit selling price of the item
• Extended – The dollar amount charged for the item. Quantity x Selling Price = Extended.

Summary by Sales Rep Page

A summary by sales rep (for above and below the line classes) displaying each of the column (headers) listed on the report.

Grand Total Above and Below the line page/section

Grand total above and below the line will be generated at the end of the report and display the following information:

• Grand Total Above – The grand total for all customers above-the-line for each of the columns (headers) listed on the report.
• Grand Total Below – The grand total for all customers below the line for each of the columns (headers) listed on the report.
• Grand Total – The grand total above minus the grand total below = grand total, for each of the columns (headers) listed on the report.

For more information on the Sales Rep Margin Report option see Sales Rep Margin Report.

Security Required : System - Profit Margin